/*
 * Copyright (C) 2011 Mette Bank, Rikke Jensen, Kenneth Brodersen, Thomas Pedersen
 * 
 * This file is part of digiPECS.
 * 
 * digiPECS is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 * 
 * digiPECS is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public License
 * along with digiPECS.  If not, see <http://www.gnu.org/licenses/>.
 */

package sw6.digipecs.database;

import android.database.sqlite.SQLiteCursor;
import android.database.sqlite.SQLiteCursorDriver;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteQuery;

public class PictureActiveCursor extends SQLiteCursor {
	private static final String[] mColumns = { DBAdapter.DB_PictureSituation_Active, DBAdapter.DB_PictureSituation_Position };
	
	public static PictureActiveCursor queryActive(SQLiteDatabase mDb, int pic_id, int sid) {
		final String select = DBAdapter.DB_PictureSituation_Picture_ID + " = " + pic_id + " AND " + DBAdapter.DB_PictureSituation_Situation_ID + " = " + sid;
		return(PictureActiveCursor) mDb.queryWithFactory(new Factory<PictureActiveCursor>(PictureActiveCursor.class), true, DBAdapter.DB_PictureSituation, mColumns, select, null, null, null, null, null);
	}
	
	private int mActiveIndex;
	private int mPositionIndex;
	public PictureActiveCursor(SQLiteDatabase db, SQLiteCursorDriver driver,
			String editTable, SQLiteQuery query) {
		super(db, driver, editTable, query);
		
		mActiveIndex = getColumnIndexOrThrow(DBAdapter.DB_PictureSituation_Active);
		mPositionIndex = getColumnIndexOrThrow(DBAdapter.DB_PictureSituation_Position);
	}
	
	public boolean getPictureActiveState() {
		final int activeState = getInt(mActiveIndex);

		return (activeState == DBAdapter.TRUE) ? true : false;
	}
	
	public int getPicturePostion(){
		return getInt(mPositionIndex);
	}
}
